﻿<%@ Page Title="Home Page" Language="vb" MasterPageFile="~/Site.Master" AutoEventWireup="false"
    CodeBehind="Default.aspx.vb" Inherits="Dabke._Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <h2>
        &nbsp;<asp:Label ID="Label1" runat="server"></asp:Label>
    </h2>
   <table width="300" style="height: 100px;" border="1">
   
   <tr >

   <td>    <span 
            style="font-size:12.0pt;line-height:200%;font-family: Times New Roman,serif; font-family: Calibri; color: #000000; font-weight: bold;">It&#39;s one of the most 
       
        important folk and folkloric dancers in the Middle East and some European 
        nations, which representing the folk heritage of those countries. In addition, 
        it&#39;s practiced always in weddings, festivals and graduation ceremonies.
    </span>    </td>

   <td>    
       <asp:Image ID="Image1" runat="server" ImageUrl="/pictures/Palestinian.jpg" 
                Height="211px" Width="407px" />    </td>


   </tr>


   <tr>
   <td>  <asp:Image ID="Image2" runat="server" ImageUrl="/pictures/Turkish.jpg" 
                Height="300px" Width="495px" />  </td>

   <td>    <span 
            style="font-size:12.0pt;line-height:200%;font-family: Times New Roman,serif; font-family: Calibri; color: #000000; font-weight: bold;"">
       It&#39;s called Dabka, Dabka troupe consists of a group usually increase nine members and 
        includes children as well (that sometimes guide the others) claiming Dbekah and 
        Alergoul player or flute and drums. Dabka is a collective oriental dance, dance 
        with simple popular songs that begin by saying poetry known in Palestine, 
        Jordan, Turkey, Lebanon, Iraq, Syria, northern Saudi Arabia and other Golf 
        countries.<br />
        
        </span>   </td>
   
   </tr>

   <tr>
       <td colspan="2">
       <p>
        lastest Five Dabkes :</p>
       <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" 
        AutoGenerateColumns="False" Width="100%" AllowSorting="True" 
        CellPadding="4" ForeColor="#333333">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:BoundField DataField="Dabka_Name" HeaderText="Dabke Name" />
            <asp:HyperLinkField DataNavigateUrlFields="ID" 
                DataNavigateUrlFormatString="Dabka_Detail.aspx?ID={0}" DataTextField="Dabka_Country" 
                HeaderText="Country" SortExpression="ID" >
            <ItemStyle HorizontalAlign="Left" VerticalAlign="Middle" />
            </asp:HyperLinkField>
            <asp:BoundField DataField="Added time" HeaderText="Added Time" 
                SortExpression="Added time" >
            <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:BoundField>
            <asp:BoundField DataField="Added by" HeaderText="Added by" 
                SortExpression="Added by" >
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:BoundField>
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <EmptyDataTemplate>
            Sorry No Data Found !!!
        </EmptyDataTemplate>
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#F5F7FB" />
        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
        <SortedDescendingCellStyle BackColor="#E9EBEF" />
        <SortedDescendingHeaderStyle BackColor="#4870BE" />
    </asp:GridView>
    </td>
   </tr>

     <tr> 

   <td colspan="2">
   <p> Top Five Dabkes Rting :</p>
   
   <asp:GridView ID="GridView2" runat="server" DataSourceID="SqlDataSource2" 
        AutoGenerateColumns="False" Width="100%" AllowSorting="True" 
        CellPadding="4" ForeColor="#333333">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:BoundField DataField="Dabka_Name" HeaderText="Dabke Name" />
            <asp:HyperLinkField DataNavigateUrlFields="ID" 
                DataNavigateUrlFormatString="Dabka_Detail.aspx?ID={0}" DataTextField="Dabka_Country" 
                HeaderText="Country" SortExpression="ID" >
            <ItemStyle HorizontalAlign="Left" VerticalAlign="Middle" />
            </asp:HyperLinkField>
            <asp:BoundField DataField="Added time" HeaderText="Added Time" 
                SortExpression="Added time" >
            <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:BoundField>
            <asp:BoundField DataField="Added by" HeaderText="Added by" 
                SortExpression="Added by" >
            <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
            </asp:BoundField>
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <EmptyDataTemplate>
            Sorry No Data Found !!!
        </EmptyDataTemplate>
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#F5F7FB" />
        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
        <SortedDescendingCellStyle BackColor="#E9EBEF" />
        <SortedDescendingHeaderStyle BackColor="#4870BE" />
    </asp:GridView>
   
   
   </td>
   </tr>
   </table>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        
        SelectCommand="SELECT TOP 5  [ID], [Dabka_Name], [Added by], [Added time] , [Dabka_Country] FROM [Dabka] ORDER BY [Added time] desc">
    </asp:SqlDataSource>

       <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
    ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        
        
        
        
        
        
        SelectCommand="SELECT Top 5 A.[ID], A.[Dabka_Name], A.[Dabka_Country], A.[Added by], A.[Added time]  FROM [Dabka] A, [Average_Rating_Query] B  where A.[ID] = B.[Dabka_fkID] order by B.AvgOfRate desc  ">
    </asp:SqlDataSource>
</asp:Content>
